The following rules apply to your entries in the Keyword field and the column filters:
Searches are not case-sensitive. You do not need to type capital letters. For example, searching for SMITH finds the same records as searching for smith.
When you search for part of a word or a character sequence, records containing related whole words or the complete character sequence will not be found. For example, searching for smith will not find records containing Smithson or Smithville. Instead, use the wildcard operator to search on partial words.